11 - Chart Object - Scatter Plot 11

Below is a picture of our completed Scatter Plot .





The first thing we need to do is select a Scatter Plot from the Charts onto our sheet. 


Next we can add our dimension and measures and apply some formatting




Now that we just need to add the measure that will determine the size of the plots



We can adjust the bubble size in the properties panel under the ‘Presentation’ tab


  • Now we can add our Target lines via the reference lines that can be found under ‘Properties’ -> ‘Add-ons’
  • For the expression for those lines we used variables that hold calculation for the averages Hit Rate and Lead Conversion.
  • This allow those lines to be dynamic when we drill down through our dimensions
  • We also gave the lines an orange color to make them standout from the chart.


After we get both target lines onto our chart we get the below product 


  • Now we can add our color formatting
  • As stated earlier the thinking here is to have color for each quadrant
  • To do so we will use the Averages (Avg Hit Rate & avg Lead Conversion) with an IF statement for the color expression
  • To format the color of the plot we need to go under ‘Properties’ -> ‘Appearance’ -> ‘Color and Legend’ 



Below is the expression for our color format. We have included a text file. You can use this to copy and paste the expression. 


Here is how it works in the graph 


Here is the working finish product